Skip to main content

Removing tmp table

Short Description

The thread is removing an internal temporary table after processing a SELECT statement.

Detailed Description​

The thread is removing an internal temporary table after processing a SELECT statement. This state is not used if no temporary table was created.

How to reduce this wait​

Temporary tables are used in sorts and merges. Tuning SQL is usually the easiest way to increase the performance of your system, so looking at the execution plan will show if there are a large amount of temporary objects being built and removed during your query.

Search online​

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.